--------------------------------------------------------
--  DDL for Trigger REPORTS_PK_TRG
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "REPORTS_PK_TRG" 
  BEFORE INSERT ON "REPORTS"
  REFERENCING FOR EACH ROW
  begin  
   if inserting then 
      if :NEW."RID" is null then 
         select REPORT_SEQ.nextval into :NEW."RID" from dual; 
      end if; 
   end if; 
end;
ALTER TRIGGER "REPORTS_PK_TRG" ENABLE
